<?xml version="1.0" encoding="UTF-8"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1746.0">
   <BatchSequence>
      <Batch>
         <Statements>
            <StmtSimple StatementText="SELECT &#xA;    Count(*) AS CommentCount,&#xA;    Score&#xA;FROM &#xA;    Comments&#xA;WHERE &#xA;    UserId = @UserId&#xA;GROUP BY &#xA;    Score&#xA;ORDER BY &#xA;    Score DESC" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSubTreeCost="140.384" StatementEstRows="6.41297" StatementOptmLevel="FULL" QueryHash="0x568DA1F0716C9E7F" QueryPlanHash="0xCD31430E3AE0C13A">
               <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
               <QueryPlan DegreeOfParallelism="8" MemoryGrant="4160" CachedPlanSize="16" CompileTime="3" CompileCPU="3" CompileMemory="256">
                  <MissingIndexes>
                     <MissingIndexGroup Impact="99.9677">
                        <MissingIndex Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]">
                           <ColumnGroup Usage="EQUALITY">
                              <Column Name="[UserId]" ColumnId="8" />
                           </ColumnGroup>
                           <ColumnGroup Usage="INCLUDE">
                              <Column Name="[Score]" ColumnId="4" />
                           </ColumnGroup>
                        </MissingIndex>
                     </MissingIndexGroup>
                  </MissingIndexes>
                  <RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6.41297" EstimateIO="0" EstimateCPU="8.3635e-005" AvgRowSize="15" EstimatedTotalSubtreeCost="140.384" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                     <OutputList>
                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                        <ColumnReference Column="Expr1003" />
                     </OutputList>
                     <ComputeScalar>
                        <DefinedValues>
                           <DefinedValue>
                              <ColumnReference Column="Expr1003" />
                              <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1006],0)">
                                 <Convert DataType="int" Style="0" Implicit="1">
                                    <ScalarOperator>
                                       <Identifier>
                                          <ColumnReference Column="Expr1006" />
                                       </Identifier>
                                    </ScalarOperator>
                                 </Convert>
                              </ScalarOperator>
                           </DefinedValue>
                        </DefinedValues>
                        <RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="6.41297" EstimateIO="0" EstimateCPU="8.3635e-005" AvgRowSize="15" EstimatedTotalSubtreeCost="140.384" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                           <OutputList>
                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                              <ColumnReference Column="Expr1006" />
                           </OutputList>
                           <RunTimeInformation>
                              <RunTimeCountersPerThread Thread="0" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                           </RunTimeInformation>
                           <StreamAggregate>
                              <DefinedValues>
                                 <DefinedValue>
                                    <ColumnReference Column="Expr1006" />
                                    <ScalarOperator ScalarString="Count(*)">
                                       <Aggregate AggType="countstar" Distinct="0" />
                                    </ScalarOperator>
                                 </DefinedValue>
                              </DefinedValues>
                              <GroupBy>
                                 <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                              </GroupBy>
                              <RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="134.048" EstimateIO="0.0112613" EstimateCPU="0.00157774" AvgRowSize="11" EstimatedTotalSubtreeCost="140.384" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList>
                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                                 </OutputList>
                                 <MemoryFractions Input="1" Output="1" />
                                 <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="413" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
                                 </RunTimeInformation>
                                 <Sort Distinct="0">
                                    <OrderBy>
                                       <OrderByColumn Ascending="0">
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                                       </OrderByColumn>
                                    </OrderBy>
                                    <RelOp NodeId="3" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="134.048" EstimateIO="0" EstimateCPU="0.0285628" AvgRowSize="11" EstimatedTotalSubtreeCost="140.371" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="413" ActualEndOfScans="1" ActualExecutions="1" />
                                       </RunTimeInformation>
                                       <Parallelism>
                                          <RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="134.048" EstimateIO="138.619" EstimateCPU="1.19948" AvgRowSize="15" EstimatedTotalSubtreeCost="139.819" TableCardinality="4.36159e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                                             </OutputList>
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="8" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="5" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="6" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="3" ActualRows="27" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="2" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="4" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="7" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="1" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                             </RunTimeInformation>
                                             <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                                <DefinedValues>
                                                   <DefinedValue>
                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="Score" />
                                                   </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Index="[idxId]" IndexKind="Clustered" />
                                                <Predicate>
                                                   <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Comments].[UserId]=[@UserId]">
                                                      <Compare CompareOp="EQ">
                                                         <ScalarOperator>
                                                            <Identifier>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Comments]" Column="UserId" />
                                                            </Identifier>
                                                         </ScalarOperator>
                                                         <ScalarOperator>
                                                            <Identifier>
                                                               <ColumnReference Column="@UserId" />
                                                            </Identifier>
                                                         </ScalarOperator>
                                                      </Compare>
                                                   </ScalarOperator>
                                                </Predicate>
                                             </IndexScan>
                                          </RelOp>
                                       </Parallelism>
                                    </RelOp>
                                 </Sort>
                              </RelOp>
                           </StreamAggregate>
                        </RelOp>
                     </ComputeScalar>
                  </RelOp>
                  <ParameterList>
                     <ColumnReference Column="@UserId" ParameterRuntimeValue="(1)" />
                  </ParameterList>
               </QueryPlan>
            </StmtSimple>
         </Statements>
      </Batch>
   </BatchSequence>
</ShowPlanXML>